package com.atung.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.atung.model.BusProvinceCity;

@Mapper
public interface BusProvinceCityDAO {

	/**
	 * 根据省获取市信息
	 * @param province
	 * @return
	 */
	@Select("select * from bus_province_city  where  province=#{province} and city=#{city} ")
	BusProvinceCity selecyBusProvinceCityByProvinceAndCity(@Param("province")String province,@Param("city")String city);

	/**
	 * 获取所有省
	 * @return
	 */
	@Select("select  province  from bus_province_city  group by province ")
	List<String> selecyBusProvinceProvince();
}
